﻿if exists (select * from dbo.sysobjects where name = 'sp_tb_User_Update')
	drop procedure [dbo].[sp_tb_User_Update]
Go 
CREATE PROCEDURE dbo.sp_tb_User_Update
@Username	varchar(50),
@Password	varchar(50),
@Address	varchar(50),
@Phone	varchar(12),
@Gender	bit,
@Status	bit
AS
UPDATE tb_User SET [Password] = @Password,[Address] = @Address,[Phone] = @Phone,[Gender] = @Gender,[Status] = @Status
WHERE  Username= @Username
Go